home *** CD-ROM | disk | FTP | other *** search
- object Form1: TForm1
- Left = 57
- Top = 76
- Width = 700
- Height = 503
- BorderIcons = [biSystemMenu, biMinimize]
- Caption = 'FormulaBuilder 1.0 Data-Aware Demo'
- Font.Color = clWindowText
- Font.Height = -16
- Font.Name = 'System'
- Font.Pitch = fpVariable
- Font.Style = []
- PixelsPerInch = 120
- Position = poScreenCenter
- OnCreate = FormCreate
- TextHeight = 20
- object FilterLabel: TLabel
- Left = 195
- Top = 15
- Width = 133
- Height = 20
- Caption = 'Filter Expression'
- FocusControl = FilterPanel
- end
- object CustomerGrid: TDBGrid
- Left = 15
- Top = 75
- Width = 661
- Height = 171
- DataSource = CustomerDataSource
- Font.Color = clBlack
- Font.Height = -17
- Font.Name = 'Arial'
- Font.Style = []
- Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
- ParentFont = False
- TabOrder = 0
- TitleFont.Color = clWindowText
- TitleFont.Height = -13
- TitleFont.Name = 'System'
- TitleFont.Style = []
- end
- object FilterPanel: TPanel
- Left = 195
- Top = 35
- Width = 421
- Height = 31
- Alignment = taLeftJustify
- Font.Color = clBlack
- Font.Height = -15
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = []
- ParentFont = False
- TabOrder = 1
- end
- object ResultsPanel: TPanel
- Left = 15
- Top = 415
- Width = 611
- Height = 41
- Alignment = taLeftJustify
- Font.Color = clBlack
- Font.Height = -15
- Font.Name = 'MS Sans Serif'
- Font.Pitch = fpVariable
- Font.Style = []
- ParentFont = False
- TabOrder = 2
- end
- object OrdersGrid: TDBGrid
- Left = 15
- Top = 270
- Width = 661
- Height = 136
- DataSource = OrdersDatasource
- Font.Color = clBlack
- Font.Height = -17
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = []
- Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit]
- ParentFont = False
- TabOrder = 3
- TitleFont.Color = clWindowText
- TitleFont.Height = -13
- TitleFont.Name = 'System'
- TitleFont.Pitch = fpVariable
- TitleFont.Style = []
- end
- object Formula: TBitBtn
- Left = 633
- Top = 415
- Width = 43
- Height = 41
- TabOrder = 4
- OnClick = FormulaClick
- Glyph.Data = {
- 78010000424D7801000000000000760000002800000020000000100000000100
- 04000000000000000000120B0000120B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
- 333333333333333333333333333333333333333FFFFFFFFFFF33330000000000
- 03333377777777777F33333003333330033333377FF333377F33333300333333
- 0333333377FF33337F3333333003333303333333377FF3337333333333003333
- 333333333377FF3333333333333003333333333333377FF33333333333330033
- 3333333333337733333333333330033333333333333773333333333333003333
- 33333333337733333F3333333003333303333333377333337F33333300333333
- 03333333773333337F33333003333330033333377FFFFFF77F33330000000000
- 03333377777777777333333333333333333333333333333333330000}
- NumGlyphs = 2
- Style = bsNew
- end
- object BitBtn3: TBitBtn
- Tag = 1
- Left = 620
- Top = 20
- Width = 56
- Height = 46
- Font.Color = clBlack
- Font.Height = -13
- Font.Name = 'Arial'
- Font.Pitch = fpVariable
- Font.Style = []
- ParentFont = False
- TabOrder = 5
- Kind = bkClose
- Layout = blGlyphTop
- Style = bsNew
- end
- object GroupBox1: TGroupBox
- Left = 15
- Top = 5
- Width = 176
- Height = 61
- Caption = '&Filter'
- TabOrder = 6
- object FilterBtn: TBitBtn
- Tag = 1
- Left = 11
- Top = 26
- Width = 80
- Height = 25
- Caption = '&Edit'
- TabOrder = 0
- OnClick = FilterBtnClick
- Glyph.Data = {
- 76010000424D7601000000000000760000002800000020000000100000000100
- 04000000000000010000130B0000130B00000000000000000000000000000000
- 800000800000008080008000000080008000808000007F7F7F00BFBFBF000000
- FF0000FF000000FFFF00FF000000FF00FF00FFFF0000FFFFFF00333333333333
- 333333333333333FF3FF3333333333CC30003333333333773777333333333C33
- 3000333FF33337F33777339933333C3333333377F33337F3333F339933333C33
- 33003377333337F33377333333333C333300333F333337F33377339333333C33
- 3333337FF3333733333F33993333C33333003377FF33733333773339933C3333
- 330033377FF73F33337733339933C33333333FF377F373F3333F993399333C33
- 330077F377F337F33377993399333C33330077FF773337F33377399993333C33
- 33333777733337F333FF333333333C33300033333333373FF7773333333333CC
- 3000333333333377377733333333333333333333333333333333}
- NumGlyphs = 2
- Style = bsNew
- end
- object cbxApplyFilter: TCheckBox
- Left = 98
- Top = 30
- Width = 68
- Height = 18
- Caption = '&Apply'
- TabOrder = 1
- OnClick = cbxApplyFilterClick
- end
- end
- object CustomerTable: TTable
- Active = True
- DatabaseName = 'DBDEMOS'
- IndexFieldNames = 'CustNo'
- ReadOnly = True
- TableName = 'CUSTOMER.DB'
- Left = 20
- Top = 128
- object CustomerTableCustNo: TFloatField
- DisplayWidth = 7
- FieldName = 'CustNo'
- end
- object CustomerTableCompany: TStringField
- DisplayWidth = 29
- FieldName = 'Company'
- Size = 30
- end
- object CustomerTableAddr1: TStringField
- DisplayWidth = 30
- FieldName = 'Addr1'
- Size = 30
- end
- object CustomerTableCity: TStringField
- DisplayWidth = 15
- FieldName = 'City'
- Size = 15
- end
- object CustomerTableState: TStringField
- DisplayWidth = 6
- FieldName = 'State'
- end
- object CustomerTableZip: TStringField
- DisplayWidth = 10
- FieldName = 'Zip'
- Size = 10
- end
- object CustomerTableCountry: TStringField
- DisplayWidth = 15
- FieldName = 'Country'
- end
- object CustomerTablePhone: TStringField
- DisplayWidth = 15
- FieldName = 'Phone'
- Size = 15
- end
- object CustomerTableFAX: TStringField
- DisplayWidth = 15
- FieldName = 'FAX'
- Size = 15
- end
- object CustomerTableTaxRate: TFloatField
- DisplayWidth = 8
- FieldName = 'TaxRate'
- end
- object CustomerTableContact: TStringField
- DisplayWidth = 20
- FieldName = 'Contact'
- end
- object CustomerTableLastInvoiceDate: TDateTimeField
- DisplayWidth = 15
- FieldName = 'LastInvoiceDate'
- end
- end
- object CustomerDataSource: TDataSource
- DataSet = CustomerTable
- OnDataChange = CustomerDataSourceDataChange
- Left = 47
- Top = 128
- end
- object OrdersDatasource: TDataSource
- DataSet = OrdersTable
- OnDataChange = OrdersDatasourceDataChange
- Left = 134
- Top = 253
- end
- object OrdersTable: TTable
- Active = True
- DatabaseName = 'DBDEMOS'
- IndexFieldNames = 'CustNo'
- MasterFields = 'CustNo'
- MasterSource = CustomerDataSource
- TableName = 'ORDERS.DB'
- Left = 169
- Top = 253
- object OrdersTableCustNo: TFloatField
- DisplayWidth = 8
- FieldName = 'CustNo'
- end
- object OrdersTableOrderNo: TFloatField
- DisplayWidth = 8
- FieldName = 'OrderNo'
- end
- object OrdersTableItemsTotal: TCurrencyField
- DisplayWidth = 12
- FieldName = 'ItemsTotal'
- Currency = True
- end
- object OrdersTableFreight: TCurrencyField
- DisplayWidth = 11
- FieldName = 'Freight'
- Currency = True
- end
- object OrdersTableAmountPaid: TCurrencyField
- DisplayWidth = 14
- FieldName = 'AmountPaid'
- Currency = True
- end
- object OrdersTablePaymentMethod: TStringField
- DisplayWidth = 16
- FieldName = 'PaymentMethod'
- Size = 7
- end
- end
- object CustomerFilter: TDSFilter
- UseExceptions = False
- Active = False
- AutoRefresh = False
- Datasource = CustomerDataSource
- LoadActivated = True
- Priority = 1
- Left = 75
- Top = 125
- end
- object DBExpression: TDBExpression
- UseExceptions = False
- Left = 510
- Top = 415
- end
- end
-